﻿CREATE TABLE [dbo].[Recycler_ContactPerson] (
    [Id]           INT              NOT NULL,
    [CustomerId]   UNIQUEIDENTIFIER NULL,
    [PersonId]     UNIQUEIDENTIFIER NULL,
    [ZName]        NVARCHAR (50)    NULL,
    [Sex]          NVARCHAR (10)    NULL,
    [Position]     NVARCHAR (50)    NULL,
    [OfficeTel]    NVARCHAR (50)    NULL,
    [HomeTel]      NVARCHAR (50)    NULL,
    [Mobile]       NVARCHAR (50)    NULL,
    [Email]        NVARCHAR (50)    NULL,
    [CreateDate]   DATETIME         NULL,
    [IsMain]       BIT              NULL,
    [PersonTypeId] INT              NULL,
    CONSTRAINT [PK_Recycler_ContactPerson] PRIMARY KEY CLUSTERED ([Id] ASC) WITH (FILLFACTOR = 90)
);

